Adding a New Cus
t
omer
Checking the Added Cust
omer - tblCUST
OMER
Cust
omer Org
aniz
ation - tblOR
GANIZA
TION
Cust
omer T
ype - tblCUS
T
OMERTYPE
Computed Column
Placing a New Or
der
Checking Pr
oducts - tblPRODUCT
T
racking or
ders – tblORDER
Employ
ee Inf
ormation - tblEMPL
O
YEE
Computed Column
Business Rule: Deliv
er
y
Ser
vice is only
a
v
ailable t
o Cust
omer
s in
W
A & CA
Ex
ecuting a st
ored pr
ocedure with illeg
al dat
a
Adding New Liv
es
tock
Lives
tock T
ype
Lives
tock Inf
ormation
Computed Column
Business Rule: No
Milking of Cow
s
y
ounger than 12
mon
ths
T
racking Activities
On F
arm - tblEVENT
T
racking Who Did Wha
t and When – tblEMPLO
YEE_EVENT